1 -- MySQL Administrator dump 1.4
2 --
3 -- ------------------------------------------------------
4 -- Server version 5.0.22-community-nt
5
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11
12 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17 --
18 -- Create schema library_management
19 --
20
21 CREATE DATABASE IF NOT EXISTS library_management;
22 USE library_management;
23
24 --
25 -- Definition of table `account`
26 --
27
28 DROP TABLE IF EXISTS `account`;
29 CREATE TABLE `account` (
30 `username` varchar(15) NOT NULL,
31 `name` varchar(25) NOT NULL,
32 `password` int(10) unsigned NOT NULL,
33 `security_ques` varchar(45) NOT NULL,
34 `answer` varchar(25) NOT NULL,
35 PRIMARY KEY (`username`)
36 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38 --
39 -- Dumping data for table `account`
40 --
41
42 /*!40000 ALTER TABLE `account` DISABLE KEYS */;
43 INSERT INTO `account` (`username`,`name`,`password`,`security_ques`,`answer`) VALUES
44 ('jakir','Jakir Hossain',15191713,'What is your mother toungue?','bangla');
45 /*!40000 ALTER TABLE `account` ENABLE KEYS */;
46
47
48 --
49 -- Definition of table `book`
50 --
51
52 DROP TABLE IF EXISTS `book`;
53 CREATE TABLE `book` (
54 `book_id` int(10) unsigned NOT NULL,
55 `name` varchar(45) NOT NULL,
56 `edition` int(10) unsigned NOT NULL,
57 `publisher` varchar(35) NOT NULL,
58 `price` int(8) unsigned NOT NULL,
59 `stock` int(8) unsigned NOT NULL,
60 PRIMARY KEY (`book_id`)
61 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63 --
64 -- Dumping data for table `book`
65 --
66
67 /*!40000 ALTER TABLE `book` DISABLE KEYS */;
68 INSERT INTO `book` (`book_id`,`name`,`edition`,`publisher`,`price`,`stock`) VALUES
69 (503,'Geetanjoli',6,'Rabindranath Tagor',220,129);
70 /*!40000 ALTER TABLE `book` ENABLE KEYS */;
71
72
73 --
74 -- Definition of table `issue`
75 --
76
77 DROP TABLE IF EXISTS `issue`;
78 CREATE TABLE `issue` (
79 `book_id` int(10) unsigned NOT NULL,
80 `b_name` varchar(25) NOT NULL,
81 `edition` int(5) unsigned NOT NULL,
82 `publisher` varchar(25) NOT NULL,
83 `price` int(5) unsigned NOT NULL,
84 `stock` int(5) unsigned NOT NULL,
85 `stu_id` int(10) unsigned NOT NULL,
86 `s_name` varchar(25) NOT NULL,
87 `f_name` varchar(25) NOT NULL,
88 `course` varchar(25) NOT NULL,
89 `branch` varchar(25) NOT NULL,
90 `year` varchar(10) NOT NULL,
91 `semister` varchar(15) NOT NULL,
92 `doi` date NOT NULL
93 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94
95 --
96 -- Dumping data for table `issue`
97 --
98
99 /*!40000 ALTER TABLE `issue` DISABLE KEYS */;
100 INSERT INTO `issue` (`book_id`,`b_name`,`edition`,`publisher`,`price`,`stock`,`stu_id`,`s_name`,`f_name`,`course`,`branch`,`year`,`semister`,`doi`) VALUES
101 (503,'Geetanjoli',6,'Rabindranath Tagor',220,130,664,'Jakir Hossain','M Uddin','BBA','Dhanmondi','4th','8th','2018-03-25');
102 /*!40000 ALTER TABLE `issue` ENABLE KEYS */;
103
104
105 --
106 -- Definition of table `returntbl`
107 --
108
109 DROP TABLE IF EXISTS `returntbl`;
110 CREATE TABLE `returntbl` (
111 `stu_id` int(10) unsigned NOT NULL,
112 `s_name` varchar(25) NOT NULL,
113 `f_name` varchar(25) NOT NULL,
114 `course` varchar(15) NOT NULL,
115 `branch` varchar(25) NOT NULL,
116 `year` varchar(15) NOT NULL,
117 `semister` varchar(15) NOT NULL,
118 `book_id` int(10) unsigned NOT NULL,
119 `b_name` varchar(25) NOT NULL,
120 `edition` varchar(25) NOT NULL,
121 `publisher` varchar(25) NOT NULL,
122 `price` int(10) unsigned NOT NULL,
123 `stock` int(10) unsigned NOT NULL,
124 `doi` date NOT NULL,
125 `doreturn` date NOT NULL
126 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
127
128 --
129 -- Dumping data for table `returntbl`
130 --
131
132 /*!40000 ALTER TABLE `returntbl` DISABLE KEYS */;
133 INSERT INTO `returntbl` (`stu_id`,`s_name`,`f_name`,`course`,`branch`,`year`,`semister`,`book_id`,`b_name`,`edition`,`publisher`,`price`,`stock`,`doi`,`doreturn`) VALUES
134 (664,'Jakir Hossain','M Uddin','BBA','Dhanmondi','4th','8th',503,'Geetanjoli','6','Rabindranath Tagor',220,128,'2018-03-20','2018-04-21'),
135 (664,'Jakir Hossain','M Uddin','BBA','Dhanmondi','4th','8th',503,'Geetanjoli','6','Rabindranath Tagor',220,128,'2018-04-25','2018-04-25'),
136 (664,'Jakir Hossain','M Uddin','BBA','Dhanmondi','4th','8th',503,'Geetanjoli','6','Rabindranath Tagor',220,129,'2018-03-25','2018-03-26');
137 /*!40000 ALTER TABLE `returntbl` ENABLE KEYS */;
138
139
140 --
141 -- Definition of table `student`
142 --
143
144 DROP TABLE IF EXISTS `student`;
145 CREATE TABLE `student` (
146 `student_id` int(10) unsigned NOT NULL,
147 `name` varchar(25) NOT NULL,
148 `fathers_name` varchar(25) NOT NULL,
149 `course` varchar(15) NOT NULL,
150 `branch` varchar(25) NOT NULL,
151 `year` varchar(15) NOT NULL,
152 `semister` varchar(15) NOT NULL,
153 PRIMARY KEY (`student_id`)
154 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
155
156 --
157 -- Dumping data for table `student`
158 --
159
160 /*!40000 ALTER TABLE `student` DISABLE KEYS */;
161 INSERT INTO `student` (`student_id`,`name`,`fathers_name`,`course`,`branch`,`year`,`semister`) VALUES
162 (664,'Jakir Hossain','M Uddin','BBA','Dhanmondi','4th','8th');
163 /*!40000 ALTER TABLE `student` ENABLE KEYS */;
164
165
166
167
168 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
169 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
170 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
171 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
172 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
173 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
174 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
